# Prerequisites

This topic list the prerequisites for using the SAP Sybase ASE source endpoint in a replication task.

## General prerequisites

* Enable SAP Sybase ASE replication for tables using the `sp_setreptable` command or set privileges to enable it automatically.

* Turn off automatic truncation by running the following command:

  `sp_dboption mydb, "trunc log on chkpt", false`

  `go`

## Prerequisites when using LogTransfer CDC

In order to use LogTransfer CDC in the [Advanced tab](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SAP%20Sybase%20ASE/adv_prop_sap_sybase_ase_target.htm), you must first disable `RepAgent` on the SAP Sybase ASE database.

## Prerequisites when using RepAgent CDC

Information noteThe RepAgent CDC type is currently in Preview.

In order to use RepAgent CDC in the [Advanced tab](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SAP%20Sybase%20ASE/adv_prop_sap_sybase_ase_target.htm), make sure you have fulfilled the following prerequisites on the SAP Sybase ASE database.

### Configure RepAgent

Configure RepAgent on Sybase ASE (using sp\_config\_rep\_agent). For more information, see [Enabling RepAgent at the Primary Database](https://help.sap.com/docs/SAP_REPLICATION_SERVER/9dc6170db0d24bb9bc901a44187b0636/ff225733bd1c1014ab0eb65d3ce6504f.html).

Information noteMake sure to set the net password encryption parameter to false as encrypted passwords are not supported.

Example syntax:

sp\_config\_rep\_agent <dbname>, enable, "REPLICATE", "xxx", "password"

sp\_config\_rep\_agent <dbname>, 'net password encryption', 'false'

Where <dbname> is the name of the Sybase ASE database.

### Edit the sql.ini file

Edit the <Sybase\_root>\ini\sql.ini (Windows) or <Sybase\_root>\interfaces (Unix) file as follows:

[REPLICATE]

master=TCP,<replicate-hostname>,11765

query=TCP,<replicate-hostname>,11765

Where <replicate-hostname> name is the IP address or host name of the Qlik Replicate server machine and 11765 is the default listening port. You can specify a different port, but whatever port you specify needs to be specified in the endpoint settings as well.

## Replicate on Windows

Install SAP Adaptive Server Enterprise ODBC Driver 16.0 or 16.1 (64-bit) on the Qlik Replicate computer.

Information noteThe Windows ODBC Driver 16.1 is only supported on Windows 2022 or later.

## Replicate on Linux

1. Stop the Replicate service and optionally confirm that it has stopped as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).

2. Install SAP Adaptive Server Enterprise ODBC Driver 16.0 or 16.1 (64-bit) on the Qlik Replicate computer.

   Information noteThe Linux ODBC Driver 16.1 is only supported on RHEL 9 or later.

3. After the driver is installed, verify that the /etc/odbcinst.ini file contains an entry for Sybase, as in the following example:

   ```
   [Adaptive Server Enterprise]    
   Description=Sybase ODBC Driver
   Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so    
   Setup=    
   FileUsage=-1    
   CPTimeout=    
   CPReuse=
   ```

4. Start the Replicate service and optionally confirm that it has started as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).